Code
# A tibble: 7 × 4
# Groups: manuf [7]
manuf Shelf_1 Shelf_2 Shelf_3
<fct> <dbl> <dbl> <dbl>
1 G 3 1.29 2.67
2 K 2.75 2.14 2.92
3 N 2.67 2.5 4
4 P 1.5 1 3
5 Q 5 2 2.5
6 R 2 NA 3
7 A NA 4 NA